/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_life_cycle.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_LIFE_CYCLE
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_life_cycle.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_LIFE_CYCLE::CTable_PPM_LIFE_CYCLE( )
 :NPCRecordSet( )
{
  setTableName( "PPM_LIFE_CYCLE" );
  prepareTable();
  prepareQuery();
 
  LIFE_CYCLE_ID.setField( "LIFE_CYCLE_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( LIFE_CYCLE_ID );
  makeKeyItem( LIFE_CYCLE_ID ); 
  PRICING_COMBINE_ID.setField( "PRICING_COMBINE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_COMBINE_ID );
  STATUS_CD.setField( "STATUS_CD", DATA_CHAR, 3, 0 );
  makeTableItem( STATUS_CD );
  EFF_TYPE.setField( "EFF_TYPE", DATA_CHAR, 3, 0 );
  makeTableItem( EFF_TYPE );
  EFF_DATE.setField( "EFF_DATE", DATA_CHAR, 14, 0 );
  makeTableItem( EFF_DATE );
  EXP_DATE.setField( "EXP_DATE", DATA_CHAR, 14, 0 );
  makeTableItem( EXP_DATE );
  RELATIVE_EFF_VALUE.setField( "RELATIVE_EFF_VALUE", DATA_DOUBLE, 22, 0 );
  makeTableItem( RELATIVE_EFF_VALUE );
  RELATIVE_EXP_VALUE.setField( "RELATIVE_EXP_VALUE", DATA_DOUBLE, 22, 0 );
  makeTableItem( RELATIVE_EXP_VALUE );
}


CTable_PPM_LIFE_CYCLE::CTable_PPM_LIFE_CYCLE( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_LIFE_CYCLE" );
  prepareTable();
  prepareQuery();
 
  LIFE_CYCLE_ID.setField( "LIFE_CYCLE_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( LIFE_CYCLE_ID );
  makeKeyItem( LIFE_CYCLE_ID ); 
  PRICING_COMBINE_ID.setField( "PRICING_COMBINE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_COMBINE_ID );
  STATUS_CD.setField( "STATUS_CD", DATA_CHAR, 3, 0 );
  makeTableItem( STATUS_CD );
  EFF_TYPE.setField( "EFF_TYPE", DATA_CHAR, 3, 0 );
  makeTableItem( EFF_TYPE );
  EFF_DATE.setField( "EFF_DATE", DATA_CHAR, 14, 0 );
  makeTableItem( EFF_DATE );
  EXP_DATE.setField( "EXP_DATE", DATA_CHAR, 14, 0 );
  makeTableItem( EXP_DATE );
  RELATIVE_EFF_VALUE.setField( "RELATIVE_EFF_VALUE", DATA_DOUBLE, 22, 0 );
  makeTableItem( RELATIVE_EFF_VALUE );
  RELATIVE_EXP_VALUE.setField( "RELATIVE_EXP_VALUE", DATA_DOUBLE, 22, 0 );
  makeTableItem( RELATIVE_EXP_VALUE );
}

CTable_PPM_LIFE_CYCLE::~CTable_PPM_LIFE_CYCLE( )
{
    close();
}

